EMT Practice Test

1. Question Content...

---

Question1: With Information Services Director, you can deploy services that package the following information provider types:
I.DataStage and QualityStage jobs
II.SOAP over HTTP
III.DB2 and Oracle SQL statements
IV.Federation Server queries

Question2: A Transformer Stage can have __________.

Question3: Which description below about the Sort Stage is invalid?

Question4: Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is correct?about the Aggregator stage? partition algorithm is correct?

Question5: Which of the following is a standard practice when using partition parallelism?

Question6: Which of the following statements is an INVALID description of the Sort Stage Option Create Key Change Column?

Question7: Which tool below can be used to assign permissions to users for each DataStage project?

Question8: Which of the following statements about partitioning algorithms is correct?

Question9: A file contains a very large number of records with unique groups based on a key. Which Grouping Method would you prefer to use in the Aggregate Stage for aggregating the data?

Question10: Which of the following is a valid Write Mode action in the Connector Stages?

Question11: How can FastTrack speed up the process of creating new source-to-target mapping specifications?
I.Reverse engineer existing DataStage jobs
II.Automatically discover column mappings using matches on column names III.Leverage metadata imported from other Information Server modules IV.FastTrack automatically converts data lineage reports into mapping specifications

Question12: In DataStage Sequential File Stage, how is a NULL value represented?

Question13: Which functionalities are supported by InfoSphere Discovery?
I.Discover primary / foreign key relationships between tables
II.Discover statistics about usage of data by users
III.Discover matching source and target columns
IV.Discover suggested transformations that, when applied, will transform the data from the source columns to match the data in the target columns

Question14: Which of the following is NOT an option for the Reject Mode setting of a Sequential File Stage?

Question15: Which of the following is NOT possible with a Transformer Stage?

Question16: Which of the following statements about Collecting methods is correct?

Question17: Which of the following statements about the Lookup Stage is correct?

Question18: Under which scenario may a user benefit from using InfoSphere Discovery?

Question19: What capability does Information Services Director provide?

Question20: In Blueprint Director, how do you easily recognize that an element contains a subdiagram?

Question21: Which Stage requires identical metadata in order to combine data?

Question22: Which of the following statements about Blueprint Director is incorrect?

Question23: What is a descriptor file of a Dataset created by the Dataset Stage?

Question24: Which type of jobs can be compiled into Orchestrate Scripting Language (OSH)?

Question25: Information Services Director provides multiple binding options. Which of the following statements about bindings is correct?

Question26: A DataStage job can be executed from_______________

Question27: With DataStage Designer you CANNOT __________.

Question28: DataStage Parallel Engine supports __________.